package com.tj.mapper;

import com.tj.pojo.SetMealDetailed;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface SetMealDetailedMapper {
    @Select("select * from setmealdetailed")
    List<SetMealDetailed> findAllList();
    @Select("select * from setmealdetailed where sdId like '%${value}%'")
    List<SetMealDetailed> findSetMealDetailedListBySdId(int sdId);
    @Select("select * from setmealdetailed where smId=#{smId}")
    SetMealDetailed findSetMealDetailedBySmId(int smId);
    @Insert("insert into setmealdetailed(sdId, smId, ciId) values (#{sdId}, #{smId}, #{ciId}")
    int insertSetMealDetailed(SetMealDetailed setMealDetailed);
    @Update("update setmealdetailed set sdId = #{sdId},smId = #{smId},ciId = #{ciId} where sdId = #{sdId}")
    int updateSetMealDetailed(SetMealDetailed setMealDetailed);
    @Delete("delete from setmealdetailed where sdId = #{sdId}")
    int deleteSetMealDetailed(SetMealDetailed setMealDetailedl);
}
